Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | Transaction(TR_TRN) |
OverrideSequenceNumber (PK) | A unique identifier (within the context of the Transaction) for this ResourceOverride. | AI_OVRD | LineNumber | smallint | |
ResourceID (FK) | A unqiue system assigned identifier for the action to which access may be granted to some Operators and Workstations. | ID_RS | Identity | integer | Resource(PA_RS) |
OperatorID (FK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
Timestamp | The date and time that a transaction line item is being overridden. | TS_LTM_RTL_TRN_OVR | AuditDateTime | datetime | |
EntryMethodCode | A code denoting how the overriding OperatorID was entered. e.g. Keyed, Scanned, MCR, SmartCard, etc... | LU_MTH_ENR | Code2 | char(2) | |
OverrideApprovalCode | Approval code entered by the overriding Operator to complete the override authorization. | CD_APVL_OVR | Code4 | char(4) | |